Overview
Brought to you by YData
Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 2371 |
| Missing cells | 9981 |
| Missing cells (%) | 28.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 903.1 KiB |
| Average record size in memory | 390.0 B |
Variable types
| Categorical | 4 |
|---|---|
| DateTime | 2 |
| Numeric | 8 |
| Text | 1 |
Air Temp Celsius is highly overall correlated with Air Temp Fahrenheit and 4 other fields | High correlation |
Air Temp Fahrenheit is highly overall correlated with Air Temp Celsius and 2 other fields | High correlation |
Dissolved Oxygen milligram per lit is highly overall correlated with UnitId and 1 other fields | High correlation |
Field Technician is highly overall correlated with WhoVerified | High correlation |
Salinity in ppt is highly overall correlated with UnitId | High correlation |
Secchi Depth meters is highly overall correlated with Water Depth meters | High correlation |
UnitId is highly overall correlated with Air Temp Celsius and 4 other fields | High correlation |
Water Depth meters is highly overall correlated with Secchi Depth meters | High correlation |
Water Temp Celsius is highly overall correlated with Air Temp Celsius and 2 other fields | High correlation |
WhoVerified is highly overall correlated with Air Temp Celsius and 2 other fields | High correlation |
pH is highly overall correlated with Air Temp Celsius | High correlation |
UnitId has 2339 (98.7%) missing values | Missing |
Salinity in ppt has 130 (5.5%) missing values | Missing |
Dissolved Oxygen milligram per lit has 851 (35.9%) missing values | Missing |
pH has 95 (4.0%) missing values | Missing |
Secchi Depth meters has 73 (3.1%) missing values | Missing |
Water Depth meters has 71 (3.0%) missing values | Missing |
Water Temp Celsius has 121 (5.1%) missing values | Missing |
Air Temp Celsius has 2286 (96.4%) missing values | Missing |
Air Temp Fahrenheit has 71 (3.0%) missing values | Missing |
Time 24 clcok has 63 (2.7%) missing values | Missing |
Field Technician has 39 (1.6%) missing values | Missing |
DateVerified has 1918 (80.9%) missing values | Missing |
WhoVerified has 1918 (80.9%) missing values | Missing |
Salinity in ppt has 1440 (60.7%) zeros | Zeros |
Reproduction
| Analysis started | 2025-02-22 18:22:28.499117 |
|---|---|
| Analysis finished | 2025-02-22 18:22:59.776558 |
| Duration | 31.28 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.6700422 |
| Min length | 1 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Bay |
|---|---|
| 2nd row | Bay |
| 3rd row | Bay |
| 4th row | Bay |
| 5th row | Bay |
Common Values
| Value | Count | Frequency (%) |
| Bay | 794 | |
| D | 440 | |
| B | 437 | |
| A | 434 | |
| C | 264 | 11.1% |
| d | 1 | < 0.1% |
| (Missing) | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| bay | 794 | |
| d | 441 | |
| b | 437 | |
| a | 434 | |
| c | 264 | 11.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 1231 | |
| a | 794 | |
| y | 794 | |
| D | 440 | 11.1% |
| A | 434 | 11.0% |
| C | 264 | 6.7% |
| d | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3958 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| B | 1231 | |
| a | 794 | |
| y | 794 | |
| D | 440 | 11.1% |
| A | 434 | 11.0% |
| C | 264 | 6.7% |
| d | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3958 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| B | 1231 | |
| a | 794 | |
| y | 794 | |
| D | 440 | 11.1% |
| A | 434 | 11.0% |
| C | 264 | 6.7% |
| d | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3958 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| B | 1231 | |
| a | 794 | |
| y | 794 | |
| D | 440 | 11.1% |
| A | 434 | 11.0% |
| C | 264 | 6.7% |
| d | 1 | < 0.1% |
UnitId
Categorical
High correlation Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | 6.2% |
| Missing | 2339 |
| Missing (%) | 98.7% |
| Memory size | 129.7 KiB |
| 01csv | |
|---|---|
| 01CSV |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 01CSV |
|---|---|
| 2nd row | 01CSV |
| 3rd row | 01CSV |
| 4th row | 01CSV |
| 5th row | 01csv |
Common Values
| Value | Count | Frequency (%) |
| 01csv | 28 | 1.2% |
| 01CSV | 4 | 0.2% |
| (Missing) | 2339 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 01csv | 32 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 32 | |
| 1 | 32 | |
| c | 28 | |
| s | 28 | |
| v | 28 | |
| C | 4 | 2.5% |
| S | 4 | 2.5% |
| V | 4 | 2.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 160 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 32 | |
| 1 | 32 | |
| c | 28 | |
| s | 28 | |
| v | 28 | |
| C | 4 | 2.5% |
| S | 4 | 2.5% |
| V | 4 | 2.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 160 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 32 | |
| 1 | 32 | |
| c | 28 | |
| s | 28 | |
| v | 28 | |
| C | 4 | 2.5% |
| S | 4 | 2.5% |
| V | 4 | 2.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 160 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 32 | |
| 1 | 32 | |
| c | 28 | |
| s | 28 | |
| v | 28 | |
| C | 4 | 2.5% |
| S | 4 | 2.5% |
| V | 4 | 2.5% |
ReadDate
Date
| Distinct | 801 |
|---|---|
| Distinct (%) | 33.9% |
| Missing | 5 |
| Missing (%) | 0.2% |
| Memory size | 18.7 KiB |
| Minimum | 1989-05-11 00:00:00 |
|---|---|
| Maximum | 2019-11-05 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
Salinity in ppt
Real number (ℝ)
High correlation Missing Zeros
| Distinct | 61 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 130 |
| Missing (%) | 5.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.71706827 |
| Minimum | 0 |
|---|---|
| Maximum | 9 |
| Zeros | 1440 |
| Zeros (%) | 60.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 18.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 3.5 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.2308187 |
|---|---|
| Coefficient of variation (CV) | 1.7164596 |
| Kurtosis | 4.2688938 |
| Mean | 0.71706827 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.9728464 |
| Sum | 1606.95 |
| Variance | 1.5149147 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1440 | |
| 1 | 245 | 10.3% |
| 3 | 92 | 3.9% |
| 2 | 84 | 3.5% |
| 1.5 | 39 | 1.6% |
| 4 | 24 | 1.0% |
| 2.5 | 20 | 0.8% |
| 0.1 | 17 | 0.7% |
| 3.5 | 16 | 0.7% |
| 1.2 | 15 | 0.6% |
| Other values (51) | 249 | 10.5% |
| (Missing) | 130 | 5.5% |
| Value | Count | Frequency (%) |
| 0 | 1440 | |
| 0.01 | 2 | 0.1% |
| 0.05 | 1 | < 0.1% |
| 0.08 | 2 | 0.1% |
| 0.09 | 1 | < 0.1% |
| 0.1 | 17 | 0.7% |
| 0.18 | 1 | < 0.1% |
| 0.2 | 5 | 0.2% |
| 0.24 | 1 | < 0.1% |
| 0.3 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9 | 2 | 0.1% |
| 8 | 2 | 0.1% |
| 6.2 | 1 | < 0.1% |
| 5.5 | 1 | < 0.1% |
| 5.4 | 1 | < 0.1% |
| 5.1 | 3 | 0.1% |
| 5 | 3 | 0.1% |
| 4.8 | 3 | 0.1% |
| 4.7 | 6 | |
| 4.5 | 11 |
Dissolved Oxygen milligram per lit
Real number (ℝ)
High correlation Missing
| Distinct | 154 |
|---|---|
| Distinct (%) | 10.1% |
| Missing | 851 |
| Missing (%) | 35.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.6462632 |
| Minimum | 0 |
|---|---|
| Maximum | 15.1 |
| Zeros | 4 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 18.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2.9 |
| Q1 | 4.8 |
| median | 6.5 |
| Q3 | 8.5 |
| 95-th percentile | 10.8 |
| Maximum | 15.1 |
| Range | 15.1 |
| Interquartile range (IQR) | 3.7 |
Descriptive statistics
| Standard deviation | 2.5066075 |
|---|---|
| Coefficient of variation (CV) | 0.37714539 |
| Kurtosis | -0.40814292 |
| Mean | 6.6462632 |
| Median Absolute Deviation (MAD) | 1.8 |
| Skewness | 0.18522675 |
| Sum | 10102.32 |
| Variance | 6.2830814 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10 | 47 | 2.0% |
| 5 | 35 | 1.5% |
| 6.3 | 33 | 1.4% |
| 6 | 32 | 1.3% |
| 4.2 | 31 | 1.3% |
| 5.9 | 30 | 1.3% |
| 5.3 | 30 | 1.3% |
| 5.2 | 28 | 1.2% |
| 8 | 27 | 1.1% |
| 6.9 | 27 | 1.1% |
| Other values (144) | 1200 | |
| (Missing) | 851 |
| Value | Count | Frequency (%) |
| 0 | 4 | |
| 0.1 | 1 | < 0.1% |
| 0.8 | 3 | |
| 1.1 | 1 | < 0.1% |
| 1.2 | 1 | < 0.1% |
| 1.35 | 1 | < 0.1% |
| 1.5 | 3 | |
| 1.6 | 2 | |
| 1.7 | 1 | < 0.1% |
| 1.8 | 3 |
| Value | Count | Frequency (%) |
| 15.1 | 1 | |
| 14.3 | 1 | |
| 14.2 | 1 | |
| 13.8 | 1 | |
| 13.3 | 1 | |
| 13.2 | 2 | |
| 13 | 1 | |
| 12.9 | 1 | |
| 12.8 | 1 | |
| 12.7 | 1 |
pH
Real number (ℝ)
High correlation Missing
| Distinct | 48 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 95 |
| Missing (%) | 4.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.1682118 |
| Minimum | 0.3 |
|---|---|
| Maximum | 9.9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 18.7 KiB |
Quantile statistics
| Minimum | 0.3 |
|---|---|
| 5-th percentile | 6.5 |
| Q1 | 6.5 |
| median | 7 |
| Q3 | 7.5 |
| 95-th percentile | 8.7 |
| Maximum | 9.9 |
| Range | 9.6 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.78848516 |
|---|---|
| Coefficient of variation (CV) | 0.10999747 |
| Kurtosis | 4.5160324 |
| Mean | 7.1682118 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | 0.26965677 |
| Sum | 16314.85 |
| Variance | 0.62170884 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=48)
| Value | Count | Frequency (%) |
| 7 | 660 | |
| 6.5 | 654 | |
| 7.5 | 242 | 10.2% |
| 8 | 144 | 6.1% |
| 6 | 81 | 3.4% |
| 8.5 | 71 | 3.0% |
| 9 | 38 | 1.6% |
| 8.1 | 26 | 1.1% |
| 8.2 | 26 | 1.1% |
| 7.9 | 24 | 1.0% |
| Other values (38) | 310 | |
| (Missing) | 95 | 4.0% |
| Value | Count | Frequency (%) |
| 0.3 | 1 | < 0.1% |
| 0.7 | 1 | < 0.1% |
| 4.8 | 1 | < 0.1% |
| 5 | 3 | 0.1% |
| 5.5 | 3 | 0.1% |
| 5.6 | 1 | < 0.1% |
| 5.7 | 1 | < 0.1% |
| 6 | 81 | |
| 6.25 | 1 | < 0.1% |
| 6.3 | 4 | 0.2% |
| Value | Count | Frequency (%) |
| 9.9 | 2 | 0.1% |
| 9.8 | 1 | < 0.1% |
| 9.7 | 1 | < 0.1% |
| 9.6 | 1 | < 0.1% |
| 9.5 | 6 | 0.3% |
| 9.4 | 2 | 0.1% |
| 9.3 | 8 | 0.3% |
| 9.2 | 12 | 0.5% |
| 9.1 | 11 | 0.5% |
| 9 | 38 |
Secchi Depth meters
Real number (ℝ)
High correlation Missing
| Distinct | 77 |
|---|---|
| Distinct (%) | 3.4% |
| Missing | 73 |
| Missing (%) | 3.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.52489774 |
| Minimum | 0 |
|---|---|
| Maximum | 9 |
| Zeros | 5 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 18.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.1 |
| Q1 | 0.3 |
| median | 0.4 |
| Q3 | 0.65 |
| 95-th percentile | 1.2 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range (IQR) | 0.35 |
Descriptive statistics
| Standard deviation | 0.47366339 |
|---|---|
| Coefficient of variation (CV) | 0.90239176 |
| Kurtosis | 88.984356 |
| Mean | 0.52489774 |
| Median Absolute Deviation (MAD) | 0.2 |
| Skewness | 7.0604798 |
| Sum | 1206.215 |
| Variance | 0.22435701 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.4 | 283 | |
| 0.3 | 277 | |
| 0.5 | 266 | |
| 0.2 | 243 | |
| 0.6 | 166 | 7.0% |
| 0.7 | 132 | 5.6% |
| 0.1 | 116 | 4.9% |
| 0.8 | 103 | 4.3% |
| 0.9 | 83 | 3.5% |
| 0.25 | 80 | 3.4% |
| Other values (67) | 549 |
| Value | Count | Frequency (%) |
| 0 | 5 | 0.2% |
| 0.01 | 3 | 0.1% |
| 0.03 | 2 | 0.1% |
| 0.05 | 9 | 0.4% |
| 0.07 | 1 | < 0.1% |
| 0.1 | 116 | |
| 0.12 | 1 | < 0.1% |
| 0.15 | 40 | 1.7% |
| 0.16 | 1 | < 0.1% |
| 0.17 | 2 | 0.1% |
| Value | Count | Frequency (%) |
| 9 | 1 | < 0.1% |
| 7.4 | 1 | < 0.1% |
| 5.8 | 1 | < 0.1% |
| 5.5 | 2 | |
| 4.5 | 2 | |
| 4 | 3 | |
| 3.5 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 2.5 | 4 | |
| 2.2 | 1 | < 0.1% |
Water Depth meters
Real number (ℝ)
High correlation Missing
| Distinct | 114 |
|---|---|
| Distinct (%) | 5.0% |
| Missing | 71 |
| Missing (%) | 3.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.7625587 |
| Minimum | 0.01 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 18.7 KiB |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 0.2 |
| Q1 | 0.4 |
| median | 0.65 |
| Q3 | 0.95 |
| 95-th percentile | 1.5 |
| Maximum | 12 |
| Range | 11.99 |
| Interquartile range (IQR) | 0.55 |
Descriptive statistics
| Standard deviation | 0.62114039 |
|---|---|
| Coefficient of variation (CV) | 0.81454764 |
| Kurtosis | 78.084693 |
| Mean | 0.7625587 |
| Median Absolute Deviation (MAD) | 0.25 |
| Skewness | 6.1938396 |
| Sum | 1753.885 |
| Variance | 0.38581538 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.5 | 179 | 7.5% |
| 0.6 | 172 | 7.3% |
| 0.3 | 158 | 6.7% |
| 0.4 | 154 | 6.5% |
| 0.7 | 153 | 6.5% |
| 0.8 | 148 | 6.2% |
| 0.9 | 138 | 5.8% |
| 0.2 | 133 | 5.6% |
| 1.5 | 86 | 3.6% |
| 1.4 | 81 | 3.4% |
| Other values (104) | 898 |
| Value | Count | Frequency (%) |
| 0.01 | 3 | 0.1% |
| 0.03 | 2 | 0.1% |
| 0.05 | 5 | 0.2% |
| 0.07 | 1 | < 0.1% |
| 0.1 | 72 | |
| 0.11 | 1 | < 0.1% |
| 0.12 | 1 | < 0.1% |
| 0.13 | 1 | < 0.1% |
| 0.14 | 1 | < 0.1% |
| 0.15 | 24 | 1.0% |
| Value | Count | Frequency (%) |
| 12 | 1 | < 0.1% |
| 8.5 | 1 | < 0.1% |
| 7.5 | 1 | < 0.1% |
| 7.4 | 1 | < 0.1% |
| 7 | 1 | < 0.1% |
| 5.8 | 1 | < 0.1% |
| 5.5 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 4.5 | 3 | |
| 4 | 1 | < 0.1% |
Water Temp Celsius
Real number (ℝ)
High correlation Missing
| Distinct | 114 |
|---|---|
| Distinct (%) | 5.1% |
| Missing | 121 |
| Missing (%) | 5.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.062138 |
| Minimum | 0 |
|---|---|
| Maximum | 74 |
| Zeros | 4 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 18.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 11 |
| median | 19 |
| Q3 | 25 |
| 95-th percentile | 29 |
| Maximum | 74 |
| Range | 74 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 8.2982461 |
|---|---|
| Coefficient of variation (CV) | 0.45942768 |
| Kurtosis | 0.41431068 |
| Mean | 18.062138 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0.13902201 |
| Sum | 40639.81 |
| Variance | 68.860888 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 27 | 127 | 5.4% |
| 26 | 120 | 5.1% |
| 28 | 117 | 4.9% |
| 25 | 116 | 4.9% |
| 20 | 88 | 3.7% |
| 13 | 82 | 3.5% |
| 12 | 82 | 3.5% |
| 10 | 80 | 3.4% |
| 14 | 79 | 3.3% |
| 9 | 75 | 3.2% |
| Other values (104) | 1284 | |
| (Missing) | 121 | 5.1% |
| Value | Count | Frequency (%) |
| 0 | 4 | 0.2% |
| 0.7 | 1 | < 0.1% |
| 0.9 | 1 | < 0.1% |
| 1 | 6 | 0.3% |
| 1.3 | 1 | < 0.1% |
| 1.6 | 1 | < 0.1% |
| 2 | 11 | |
| 2.5 | 2 | 0.1% |
| 3 | 22 | |
| 3.5 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 74 | 1 | < 0.1% |
| 60 | 1 | < 0.1% |
| 59 | 1 | < 0.1% |
| 54 | 1 | < 0.1% |
| 48 | 1 | < 0.1% |
| 43 | 1 | < 0.1% |
| 42.5 | 1 | < 0.1% |
| 35 | 2 | |
| 34.5 | 2 | |
| 34 | 3 |
Air Temp Celsius
Real number (ℝ)
High correlation Missing
| Distinct | 45 |
|---|---|
| Distinct (%) | 52.9% |
| Missing | 2286 |
| Missing (%) | 96.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.437647 |
| Minimum | 0 |
|---|---|
| Maximum | 74 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 18.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 9 |
| median | 15 |
| Q3 | 21.7 |
| 95-th percentile | 28.4 |
| Maximum | 74 |
| Range | 74 |
| Interquartile range (IQR) | 12.7 |
Descriptive statistics
| Standard deviation | 11.754138 |
|---|---|
| Coefficient of variation (CV) | 0.71507423 |
| Kurtosis | 12.079605 |
| Mean | 16.437647 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 2.796289 |
| Sum | 1397.2 |
| Variance | 138.15976 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=45)
| Value | Count | Frequency (%) |
| 9 | 7 | 0.3% |
| 13 | 6 | 0.3% |
| 19 | 5 | 0.2% |
| 8 | 4 | 0.2% |
| 7 | 4 | 0.2% |
| 3 | 4 | 0.2% |
| 16 | 4 | 0.2% |
| 11 | 3 | 0.1% |
| 10 | 3 | 0.1% |
| 15 | 3 | 0.1% |
| Other values (35) | 42 | 1.8% |
| (Missing) | 2286 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 2.6 | 1 | < 0.1% |
| 2.7 | 1 | < 0.1% |
| 3 | 4 | |
| 5 | 1 | < 0.1% |
| 7 | 4 | |
| 7.6 | 1 | < 0.1% |
| 8 | 4 | |
| 9 | 7 | |
| 9.5 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 74 | 2 | |
| 37 | 1 | |
| 30.5 | 1 | |
| 28.5 | 1 | |
| 28 | 1 | |
| 27.9 | 1 | |
| 27 | 1 | |
| 26.9 | 1 | |
| 25.7 | 1 | |
| 25.5 | 1 |
Air Temp Fahrenheit
Real number (ℝ)
High correlation Missing
| Distinct | 225 |
|---|---|
| Distinct (%) | 9.8% |
| Missing | 71 |
| Missing (%) | 3.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 62.051637 |
| Minimum | 10.5 |
|---|---|
| Maximum | 92.3 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 18.7 KiB |
Quantile statistics
| Minimum | 10.5 |
|---|---|
| 5-th percentile | 37 |
| Q1 | 49 |
| median | 63 |
| Q3 | 75 |
| 95-th percentile | 83 |
| Maximum | 92.3 |
| Range | 81.8 |
| Interquartile range (IQR) | 26 |
Descriptive statistics
| Standard deviation | 15.492236 |
|---|---|
| Coefficient of variation (CV) | 0.24966685 |
| Kurtosis | -0.73817032 |
| Mean | 62.051637 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | -0.35926572 |
| Sum | 142718.76 |
| Variance | 240.00939 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 48 | 85 | 3.6% |
| 80 | 66 | 2.8% |
| 70 | 66 | 2.8% |
| 72 | 63 | 2.7% |
| 58 | 59 | 2.5% |
| 45 | 58 | 2.4% |
| 60 | 58 | 2.4% |
| 82 | 55 | 2.3% |
| 78 | 55 | 2.3% |
| 73 | 53 | 2.2% |
| Other values (215) | 1682 | |
| (Missing) | 71 | 3.0% |
| Value | Count | Frequency (%) |
| 10.5 | 1 | < 0.1% |
| 11.5 | 1 | < 0.1% |
| 12 | 1 | < 0.1% |
| 14.5 | 1 | < 0.1% |
| 17 | 1 | < 0.1% |
| 21 | 1 | < 0.1% |
| 22 | 1 | < 0.1% |
| 23 | 2 | 0.1% |
| 25 | 4 | 0.2% |
| 26 | 15 |
| Value | Count | Frequency (%) |
| 92.3 | 1 | < 0.1% |
| 91.4 | 1 | < 0.1% |
| 90.5 | 1 | < 0.1% |
| 89 | 2 | 0.1% |
| 88.7 | 1 | < 0.1% |
| 88 | 5 | 0.2% |
| 87.8 | 5 | 0.2% |
| 87.4 | 1 | < 0.1% |
| 87.1 | 1 | < 0.1% |
| 87 | 14 |
Time 24 clcok
Text
Missing
| Distinct | 90 |
|---|---|
| Distinct (%) | 3.9% |
| Missing | 63 |
| Missing (%) | 2.7% |
| Memory size | 117.5 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 1 |
| Mean length | 2.1889081 |
| Min length | 1 |
Unique
| Unique | 34 ? |
|---|---|
| Unique (%) | 1.5% |
Sample
| 1st row | 11 |
|---|---|
| 2nd row | 11.3 |
| 3rd row | 9.45 |
| 4th row | 10.3 |
| 5th row | 10 |
| Value | Count | Frequency (%) |
| 0 | 1440 | |
| 14.24 | 52 | 2.3% |
| 19.12 | 47 | 2.0% |
| 4.48 | 46 | 2.0% |
| 9.36 | 44 | 1.9% |
| 10.15 | 42 | 1.8% |
| 10.45 | 39 | 1.7% |
| 9.45 | 38 | 1.6% |
| 21.36 | 37 | 1.6% |
| 12 | 36 | 1.6% |
| Other values (80) | 487 | 21.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1774 | |
| 1 | 848 | |
| . | 779 | |
| 4 | 374 | 7.4% |
| 2 | 317 | 6.3% |
| 5 | 294 | 5.8% |
| 9 | 213 | 4.2% |
| 3 | 210 | 4.2% |
| 6 | 111 | 2.2% |
| 8 | 88 | 1.7% |
| Other values (3) | 44 | 0.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5052 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1774 | |
| 1 | 848 | |
| . | 779 | |
| 4 | 374 | 7.4% |
| 2 | 317 | 6.3% |
| 5 | 294 | 5.8% |
| 9 | 213 | 4.2% |
| 3 | 210 | 4.2% |
| 6 | 111 | 2.2% |
| 8 | 88 | 1.7% |
| Other values (3) | 44 | 0.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5052 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1774 | |
| 1 | 848 | |
| . | 779 | |
| 4 | 374 | 7.4% |
| 2 | 317 | 6.3% |
| 5 | 294 | 5.8% |
| 9 | 213 | 4.2% |
| 3 | 210 | 4.2% |
| 6 | 111 | 2.2% |
| 8 | 88 | 1.7% |
| Other values (3) | 44 | 0.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5052 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1774 | |
| 1 | 848 | |
| . | 779 | |
| 4 | 374 | 7.4% |
| 2 | 317 | 6.3% |
| 5 | 294 | 5.8% |
| 9 | 213 | 4.2% |
| 3 | 210 | 4.2% |
| 6 | 111 | 2.2% |
| 8 | 88 | 1.7% |
| Other values (3) | 44 | 0.9% |
Field Technician
Categorical
High correlation Missing
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 39 |
| Missing (%) | 1.6% |
| Memory size | 137.2 KiB |
| Not Recorded | |
|---|---|
| S. Poe | |
| Sue Poe | |
| Feldman | |
| Susan Poe | 86 |
| Other values (9) |
Length
| Max length | 24 |
|---|---|
| Median length | 12 |
| Mean length | 10.231132 |
| Min length | 6 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | John Phillips |
|---|---|
| 2nd row | John Phillips |
| 3rd row | John Phillips |
| 4th row | John Phillips |
| 5th row | John Phillips |
Common Values
| Value | Count | Frequency (%) |
| Not Recorded | 1225 | |
| S. Poe | 358 | 15.1% |
| Sue Poe | 342 | 14.4% |
| Feldman | 172 | 7.3% |
| Susan Poe | 86 | 3.6% |
| J Phillips, Mary Feldman | 37 | 1.6% |
| Strader, Pease, Feldman | 35 | 1.5% |
| Pease, Strader | 31 | 1.3% |
| John Phillips | 17 | 0.7% |
| Strader | 15 | 0.6% |
| Other values (4) | 14 | 0.6% |
| (Missing) | 39 | 1.6% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| not | 1225 | |
| recorded | 1225 | |
| poe | 800 | |
| s | 369 | 8.0% |
| sue | 345 | 7.5% |
| feldman | 244 | 5.3% |
| strader | 92 | 2.0% |
| susan | 86 | 1.9% |
| pease | 66 | 1.4% |
| phillips | 54 | 1.2% |
| Other values (3) | 91 | 2.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 4062 | |
| o | 3266 | |
| d | 2786 | |
| 2265 | ||
| r | 1446 | 6.1% |
| t | 1317 | 5.5% |
| N | 1225 | 5.1% |
| R | 1225 | 5.1% |
| c | 1225 | 5.1% |
| P | 919 | 3.9% |
| Other values (18) | 4123 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 23859 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 4062 | |
| o | 3266 | |
| d | 2786 | |
| 2265 | ||
| r | 1446 | 6.1% |
| t | 1317 | 5.5% |
| N | 1225 | 5.1% |
| R | 1225 | 5.1% |
| c | 1225 | 5.1% |
| P | 919 | 3.9% |
| Other values (18) | 4123 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 23859 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 4062 | |
| o | 3266 | |
| d | 2786 | |
| 2265 | ||
| r | 1446 | 6.1% |
| t | 1317 | 5.5% |
| N | 1225 | 5.1% |
| R | 1225 | 5.1% |
| c | 1225 | 5.1% |
| P | 919 | 3.9% |
| Other values (18) | 4123 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 23859 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 4062 | |
| o | 3266 | |
| d | 2786 | |
| 2265 | ||
| r | 1446 | 6.1% |
| t | 1317 | 5.5% |
| N | 1225 | 5.1% |
| R | 1225 | 5.1% |
| c | 1225 | 5.1% |
| P | 919 | 3.9% |
| Other values (18) | 4123 |
DateVerified
Date
Missing
| Distinct | 44 |
|---|---|
| Distinct (%) | 9.7% |
| Missing | 1918 |
| Missing (%) | 80.9% |
| Memory size | 18.7 KiB |
| Minimum | 2014-03-27 00:00:00 |
|---|---|
| Maximum | 2019-11-13 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=44)
WhoVerified
Categorical
High correlation Missing
| Distinct | 12 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 1918 |
| Missing (%) | 80.9% |
| Memory size | 132.8 KiB |
| Christine Folks | |
|---|---|
| Kayla Braasch | |
| Carly Sibilia | |
| Rebecca Walawender | |
| Erin Bailey | |
| Other values (7) |
Length
| Max length | 18 |
|---|---|
| Median length | 15 |
| Mean length | 13.874172 |
| Min length | 8 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | Karen Beatty |
|---|---|
| 2nd row | Karen Beatty |
| 3rd row | Karen Beatty |
| 4th row | Karen Beatty |
| 5th row | Karen Beatty |
Common Values
| Value | Count | Frequency (%) |
| Christine Folks | 171 | 7.2% |
| Kayla Braasch | 62 | 2.6% |
| Carly Sibilia | 53 | 2.2% |
| Rebecca Walawender | 51 | 2.2% |
| Erin Bailey | 40 | 1.7% |
| Karen Beatty | 28 | 1.2% |
| Amy Keiler | 23 | 1.0% |
| Karen Callaway | 12 | 0.5% |
| K Beatty | 5 | 0.2% |
| Trenton Miller | 4 | 0.2% |
| Other values (2) | 4 | 0.2% |
| (Missing) | 1918 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| christine | 171 | |
| folks | 171 | |
| kayla | 62 | 6.8% |
| braasch | 62 | 6.8% |
| carly | 53 | 5.8% |
| sibilia | 53 | 5.8% |
| rebecca | 51 | 5.6% |
| walawender | 51 | 5.6% |
| karen | 40 | 4.4% |
| bailey | 40 | 4.4% |
| Other values (8) | 152 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 660 | 10.5% |
| i | 609 | 9.7% |
| e | 547 | 8.7% |
| l | 486 | 7.7% |
| 453 | 7.2% | |
| r | 449 | 7.1% |
| s | 404 | 6.4% |
| n | 310 | 4.9% |
| t | 247 | 3.9% |
| C | 236 | 3.8% |
| Other values (20) | 1884 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6285 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 660 | 10.5% |
| i | 609 | 9.7% |
| e | 547 | 8.7% |
| l | 486 | 7.7% |
| 453 | 7.2% | |
| r | 449 | 7.1% |
| s | 404 | 6.4% |
| n | 310 | 4.9% |
| t | 247 | 3.9% |
| C | 236 | 3.8% |
| Other values (20) | 1884 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6285 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 660 | 10.5% |
| i | 609 | 9.7% |
| e | 547 | 8.7% |
| l | 486 | 7.7% |
| 453 | 7.2% | |
| r | 449 | 7.1% |
| s | 404 | 6.4% |
| n | 310 | 4.9% |
| t | 247 | 3.9% |
| C | 236 | 3.8% |
| Other values (20) | 1884 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6285 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 660 | 10.5% |
| i | 609 | 9.7% |
| e | 547 | 8.7% |
| l | 486 | 7.7% |
| 453 | 7.2% | |
| r | 449 | 7.1% |
| s | 404 | 6.4% |
| n | 310 | 4.9% |
| t | 247 | 3.9% |
| C | 236 | 3.8% |
| Other values (20) | 1884 |
Interactions
Correlations
| Air Temp Celsius | Air Temp Fahrenheit | Dissolved Oxygen milligram per lit | Field Technician | Salinity in ppt | Secchi Depth meters | SiteId | UnitId | Water Depth meters | Water Temp Celsius | WhoVerified | pH | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Air Temp Celsius | 1.000 | 0.860 | -0.076 | 0.000 | 0.342 | -0.061 | 0.342 | 1.000 | 0.230 | 0.907 | 0.893 | 0.579 |
| Air Temp Fahrenheit | 0.860 | 1.000 | -0.447 | 0.058 | 0.022 | -0.036 | 0.000 | 0.739 | 0.022 | 0.914 | 0.322 | 0.226 |
| Dissolved Oxygen milligram per lit | -0.076 | -0.447 | 1.000 | 0.236 | 0.348 | -0.142 | 0.206 | 0.540 | 0.024 | -0.523 | 0.264 | 0.080 |
| Field Technician | 0.000 | 0.058 | 0.236 | 1.000 | 0.286 | 0.076 | 0.402 | 0.000 | 0.084 | 0.000 | 0.707 | 0.169 |
| Salinity in ppt | 0.342 | 0.022 | 0.348 | 0.286 | 1.000 | -0.230 | 0.196 | 1.000 | -0.089 | -0.057 | 0.000 | 0.382 |
| Secchi Depth meters | -0.061 | -0.036 | -0.142 | 0.076 | -0.230 | 1.000 | 0.222 | 0.000 | 0.750 | -0.010 | 0.000 | -0.272 |
| SiteId | 0.342 | 0.000 | 0.206 | 0.402 | 0.196 | 0.222 | 1.000 | 0.296 | 0.342 | 0.054 | 0.204 | 0.157 |
| UnitId | 1.000 | 0.739 | 0.540 | 0.000 | 1.000 | 0.000 | 0.296 | 1.000 | 0.000 | 0.000 | 0.981 | 0.000 |
| Water Depth meters | 0.230 | 0.022 | 0.024 | 0.084 | -0.089 | 0.750 | 0.342 | 0.000 | 1.000 | 0.022 | 0.000 | -0.254 |
| Water Temp Celsius | 0.907 | 0.914 | -0.523 | 0.000 | -0.057 | -0.010 | 0.054 | 0.000 | 0.022 | 1.000 | 0.328 | 0.190 |
| WhoVerified | 0.893 | 0.322 | 0.264 | 0.707 | 0.000 | 0.000 | 0.204 | 0.981 | 0.000 | 0.328 | 1.000 | 0.137 |
| pH | 0.579 | 0.226 | 0.080 | 0.169 | 0.382 | -0.272 | 0.157 | 0.000 | -0.254 | 0.190 | 0.137 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| SiteId | UnitId | ReadDate | Salinity in ppt | Dissolved Oxygen milligram per lit | pH | Secchi Depth meters | Water Depth meters | Water Temp Celsius | Air Temp Celsius | Air Temp Fahrenheit | Time 24 clcok | Field Technician | DateVerified | WhoVerified | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Bay | NaN | 01-03-1994 | 1.3 | 11.7 | 7.3 | 0.40 | 0.40 | 5.9 | 8.0 | 46.40 | 11 | NaN | NaN | NaN |
| 1 | Bay | NaN | 1/31/1994 | 1.5 | 12.0 | 7.4 | 0.20 | 0.35 | 3.0 | 2.6 | 36.68 | 11.3 | NaN | NaN | NaN |
| 2 | Bay | NaN | 02-07-1994 | 1.0 | 10.5 | 7.2 | 0.25 | 0.60 | 5.9 | 7.6 | 45.68 | 9.45 | NaN | NaN | NaN |
| 3 | Bay | NaN | 2/23/1994 | 1.0 | 10.1 | 7.4 | 0.35 | 0.50 | 10.0 | 2.7 | 36.86 | NaN | NaN | NaN | NaN |
| 4 | Bay | NaN | 2/28/1994 | 1.0 | 12.6 | 7.2 | 0.20 | 0.40 | 1.6 | 0.0 | 32.00 | 10.3 | NaN | NaN | NaN |
| 5 | Bay | NaN | 03-07-1994 | 1.0 | 9.9 | 7.1 | 0.20 | 0.90 | 9.7 | 15.2 | 59.36 | 10 | NaN | NaN | NaN |
| 6 | Bay | NaN | 3/14/1994 | 0.5 | 10.4 | 7.2 | 0.25 | 0.75 | 9.8 | 10.1 | 50.18 | 11 | NaN | NaN | NaN |
| 7 | Bay | NaN | 3/28/1994 | 1.0 | 9.2 | 7.1 | 0.15 | 0.95 | 16.1 | 22.1 | 71.78 | 9.5 | NaN | NaN | NaN |
| 8 | Bay | NaN | 04-04-1994 | 1.0 | 9.2 | 7.2 | 0.25 | 0.75 | 15.0 | 13.5 | 56.30 | 10 | NaN | NaN | NaN |
| 9 | Bay | NaN | 04-11-1994 | 1.0 | 8.6 | 7.3 | 0.20 | 0.75 | 15.7 | 13.0 | 55.40 | 10 | NaN | NaN | NaN |
| SiteId | UnitId | ReadDate | Salinity in ppt | Dissolved Oxygen milligram per lit | pH | Secchi Depth meters | Water Depth meters | Water Temp Celsius | Air Temp Celsius | Air Temp Fahrenheit | Time 24 clcok | Field Technician | DateVerified | WhoVerified | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2361 | D | NaN | 10-11-2018 | 0.0 | 6.0 | 6.5 | 0.70 | 1.2 | 26.0 | NaN | 78.0 | 10.1 | Sue Poe | 11-12-2019 | Christine Folks |
| 2362 | D | NaN | 10/24/2018 | 0.0 | NaN | 6.5 | 0.60 | 1.3 | 16.0 | NaN | 58.0 | 10.15 | Sue Poe | 11-12-2019 | Christine Folks |
| 2363 | D | NaN | 10/28/2018 | 0.0 | NaN | 6.5 | 1.10 | 1.2 | 13.0 | NaN | 49.0 | 10.15 | Sue Poe | 11-12-2019 | Christine Folks |
| 2364 | D | NaN | 11-07-2018 | 0.0 | 6.9 | 6.5 | 0.90 | 1.3 | 20.0 | NaN | 65.0 | 10.22 | Sue Poe | 11-12-2019 | Christine Folks |
| 2365 | D | NaN | 12-11-2018 | 0.0 | NaN | 6.5 | 1.20 | 1.4 | 11.0 | NaN | 42.0 | 10.15 | Sue Poe | 11-12-2019 | Christine Folks |
| 2366 | Bay | NaN | 10-11-2018 | 1.9 | 5.0 | 7.0 | 4.00 | 1.2 | 25.0 | NaN | 78.0 | 9.3 | Sue Poe | 11/13/2019 | Christine Folks |
| 2367 | Bay | NaN | 10/24/2018 | 0.0 | 9.0 | 7.0 | 0.30 | 0.6 | 18.0 | NaN | 58.0 | 9.3 | Sue Poe | 11/13/2019 | Christine Folks |
| 2368 | Bay | NaN | 10/28/2018 | 0.9 | 2.9 | 7.0 | 0.40 | 0.9 | 13.0 | NaN | 49.0 | 9.2 | Sue Poe | 11/13/2019 | Christine Folks |
| 2369 | Bay | NaN | 11-07-2018 | 1.7 | NaN | 7.0 | 0.45 | 0.9 | 20.0 | NaN | 65.0 | 9.45 | Sue Poe | 11/13/2019 | Christine Folks |
| 2370 | Bay | NaN | 12-11-2018 | 0.1 | NaN | 7.0 | 0.10 | 0.1 | 10.0 | NaN | 42.0 | 9.4 | Sue Poe | 11/13/2019 | Christine Folks |